Forum Discussion

RPAI2812's avatar
RPAI2812
Helper I
4 years ago
Solved

Reorganizing data

Hi, I wanted some help to rearrange my table in Power Query 🙂 Currently, I have one column for each initial and end date for three different trips.    Person Start Trip 1 End Trip 1 Start T...
Need Help
  • HotChilli's avatar
    HotChilli
    4 years ago

    Yes it's an Unpivot (all date columns).

    Split the resulting column (by Space as far right as possible)-> that gets the numbers into a column.

    Then Pivot the 'Start Trip'/End Trip' Column with Don't Aggregate

HotChilli's avatar
HotChilli
Community Champion
4 years ago

Yes it's an Unpivot (all date columns).

Split the resulting column (by Space as far right as possible)-> that gets the numbers into a column.

Then Pivot the 'Start Trip'/End Trip' Column with Don't Aggregate