lundi 9 septembre 2019

Using vertical information to populate a horizontal table

I have a very perplexing dilemma which I am unsure how to resolve. I have copied the issue into Google Sheets here: https://docs.google.com/spreadsheets/d/1OKaGqqxMJS7OCvixQvpmBqelyh24DlV9nSa1QsT4yCk/edit?usp=sharing

So columns I,J, and K all have information that needs to be entered into the table (columns A-F).

Columns D,E, and F have to be manually entered no matter what however information will consistently copy and pasted from another source into the three columns I,J,K. I need to pull out the Date and put it into Column B, The remaining content of a cell in column C, and the hall (located at the top of the column) in column A.

As you can see in the page above, the "Before" sheet is when the data is pasted into the I,J,K columns.

I would like this data to automatically populate the appropriate columns (A-C) upon the paste ("After" sheet)

This information will be updated many times over the year so at any paste, the table should be updated.

Ideally it is ordered by date.

Aucun commentaire:

Enregistrer un commentaire