Hi there,
I have a spreadsheet that I'm having issues with. I have a matrix which counts the number of items connected to an ID, which has 1 row. In order for this data to be useful to our developers I need the ID to be repeated by the number of column headers, bringing them into a new column and then bring the quantity into a new column also.
I have attached a spreadsheet which shows examples of 'What I have' and 'What I need' on 2 tabs.
If someone could offer advice that'd be great!
Thanks,
Jenny
Bookmarks