Combine multiple rows to one single row based on common ID.

[Anonymous]

I have some issue to shift data from rows to combine to just one row based on a common ID (column A)

Below is my original data set:

WIP_NO	STAGES	START_TIME	END_TIME	STATUS	QTY	REJECTED_QTY
ED8166	1	02/10/2018 9:05:00 AM	02/10/2018 9:05:00 AM	2	1	0
ED8166	2	02/10/2018 9:05:00 AM	02/10/2018 9:05:00 AM	2	1	0
ED8166	3	02/10/2018 9:05:00 AM	02/10/2018 9:06:00 AM	2	1	0
ED8166	4	02/10/2018 9:06:00 AM	02/10/2018 9:06:00 AM	2	1	0
ED8166	5	22/10/2018 4:32:00 PM	22/10/2018 4:33:00 PM	2	1	0
ED8166	6	23/10/2018 9:28:00 AM	23/10/2018 9:28:00 AM	2	1	0
ED8166	7	24/10/2018 9:55:00 AM	24/10/2018 9:56:00 AM	2	1	0

I like to reshape it to something like this:

WIP_NO

STAGES

START_TIME

END_TIME

STATUS

QTY

REJECTED_QTY

STAGES

START_TIME

END_TIME

STATUS

QTY

REJECTED_QTY

STAGES

START_TIME

END_TIME

STATUS

QTY

REJECTED_QTY

STAGES

START_TIME

END_TIME

STATUS

QTY

REJECTED_QTY

STAGES

START_TIME

END_TIME

STATUS

QTY

REJECTED_QTY

STAGES

START_TIME

END_TIME

STATUS

QTY

REJECTED_QTY

STAGES

START_TIME

END_TIME

STATUS

QTY

REJECTED_QTY

ED8166

1

02/10/2018 9:05:00 AM

02/10/2018 9:05:00 AM

2

1

0

2

02/10/2018 9:05:00 AM

02/10/2018 9:05:00 AM

2

1

0

3

02/10/2018 9:05:00 AM

02/10/2018 9:06:00 AM

2

1

0

4

02/10/2018 9:06:00 AM

02/10/2018 9:06:00 AM

2

1

0

5

22/10/2018 4:32:00 PM

22/10/2018 4:33:00 PM

2

1

0

6

23/10/2018 9:28:00 AM

23/10/2018 9:28:00 AM

2

1

0

7

24/10/2018 9:55:00 AM

24/10/2018 9:56:00 AM

2

1

0

[Mariusz · Accepted solution]

Hi @Anonymous 

You can use Power Query to do this, it takes three steps, please see the attached file.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

[Anonymous]

Thanks!

It's what Im looking for!