Forum Discussion
Messy Raw Data
Double row header is not a problem:
1. Tanspose data
2. Merge first two columns
3. Transpose data
4. Promote first row as headers
I don't believe that handles the double rows of data
oh sorry, i missed the part on rows being affected too. Urgh, horrible situation. Okay,
1. Bring in the data and make sure its in an order where the rows are in their order ie row 1a, row 1b, row row 2a, row 2b etc.
2. Add index column starting at 1 and filter for even numbers only,
3. Duplicate query and change the filter step to odd numbers only
4. On the 'odds' table create a custom column which is index +1.
5. Merge the two tables using the index from the 'evens' and the custom from the 'odds'
6. Expand out the data.
So long as the sorting in the first step is solid. this will work fine. Do the first suggestion too, sorting out the double row headers.
Thanks for responding again. Unfortunately the data is sometimes over 1 row, sometimes 2 and sometimes 3 (depending on what elements are updated).