You’re offline. This is a read only version of the page.
9
Hi
I'm trying to merge two columns of data together in Excel's power query editor. Both of them came from separate csv files.
So far, I have the following result.
| Timestamp | Value1 | Value2 |
| 01-Jun-24 12:00 AM PDT | 14.76 | |
| 01-Jun-24 12:00 AM PDT | 13.82 | |
| 01-Jun-24 12:15 AM PDT | 15.13 | |
| 01-Jun-24 12:15 AM PDT | 13.43 | |
| 01-Jun-24 12:30 AM PDT | 15.04 | |
| 01-Jun-24 12:30 AM PDT | 13.54 | |
| 01-Jun-24 12:45 AM PDT | 15.09 | |
| 01-Jun-24 12:45 AM PDT | 13.73 |
Eventually, I would like to have convert the above into the table below (if same timestamp as Value 1, "merge" together into a single row.)
| Timestamp | Value1 | Value2 |
| 01-Jun-24 12:00 AM PDT | 14.76 | 13.82 |
| 01-Jun-24 12:15 AM PDT | 15.13 | 13.43 |
| 01-Jun-24 12:30 AM PDT | 15.04 | 13.54 |
| 01-Jun-24 12:45 AM PDT | 15.09 | 13.73 |
What's the best way to go about this in power query editor?
It looks like I was able to solve it using a combination of unpivoting columns and pivoting them in power query.
Attributing Ashish Matur's post as power query code source
I will close this as it is solved.
Share
Report
All responses (
Answers (
