Forum Discussion
Rearrange Data from Rows to Columns based on Time
You could solve this using Power Query if that is an option for you. This is the final Product.
- Make data a table
- Get Data From Table/Range
- Highlight Sequence Column
- Go to Transform Tab
- Select Pivot Column
- Values Column Should = Location
- Click arrow by advanced options and Select “Don’t Aggregate”
- Hit Okay
- Go to Home Tab
- Click Close and Load
You could solve this using Power Query if that is an option for you. This is the final Product.
- Make data a table
- Get Data From Table/Range
- Highlight Sequence Column
- Go to Transform Tab
- Select Pivot Column
- Values Column Should = Location
- Click arrow by advanced options and Select “Don’t Aggregate”
- Hit Okay
- Go to Home Tab
- Click Close and Load
Oh nice, what you have there looks about perfect! I do appear to have access to the Power Query function, although I'm unfamiliar with it at this point in time. I've managed to follow your directions up to this point in time:
The bullet points listed direct me to "Select Pivot Column" and that the "Values Column Should = Location". I apologize if this is something fairly obvious I'm missing, but could you provide me with step-by-step directions on how to complete the operations from the point I posted until the end so I can create a table similar to the table you provided? I really appreciate your assistance!
Highlight sequence column, Go to Transform Tab, Select Pivot Column
Values Column = Location, Advanced options "Don't Aggregate"
Hope the snips help! : )