asked on

Data reordering - Moving Data from mutiple columns into multiple rows

I need to reorder data on the attached spreadsheet. I need the Date and Amounts from View 1 to line up and look like View 2

View 2 has a date per record and the cumulative hours next to the date, but everything is in one column

I have over 60,000 lines items and 3 tabs to format, so a nice formula to do it quickly would be best, Thank you
EE---Column-Reordering.xlsx

ASKER CERTIFIED SOLUTION

Subodh Tiwari (Neeraj)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Ejgil Hedegaard

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Anastasia D. Gavanas

Ejgil has provided a solid solution, however, you may want to consider ordering/labelling your data so that a PIVOT table can be used to do this grouping you want, as there may be may rows/records to index/match

Audra Breedlove

ASKER

I was able to find the Pivot Query and it was amazing, but I'm glad that a formula was sent as well, so that I could deconstruct the formula and understand how MATCH/INDEX works

Subodh Tiwari (Neeraj)

Here is a Power Query Solution and to me it is more robust and dynamic enough to incorporate more data you add in the Table1 on the sheet other than 60000 rows of existing data.
After adding more data, you just need to right click the Table on Sheet2 and choose Refresh and the new data will be reflected in the table on sheet2 automatically.

See if that helps.
EE---Column-Reordering.xlsx

Audra Breedlove

ASKER

I was able to find the Pivot Query and it was amazing and took seconds, but I'm glad that a formula was sent as well, so that I could deconstruct the formula and understand how MATCH/INDEX works

Subodh Tiwari (Neeraj)

You're welcome. Glad we could help.