Hello All,
I have a spreadsheet that I get each week which is filled with data. However there are duplicate column headings and the data is spread out across the spreadsheet making it difficult to retrieve or graph/trend any data.
Is there a way to use visual basic to sort this table with multiple duplicate column headings into a table with only single column headings for each sample number?
I have attached a basic example of what I mean below.
Example.xlsx
Thanks
Stephen
Bookmarks