Help creating a Macro or Query

[Cmac941]

Hello Everyone,

I am new to Access and trying to figure out how I can accomplish this project.

Below is my current data in Access. I need to compile the sequenced data based on the duplicates in column LGLOGO with the red arrow but by the sequence of numbers in column LGSEQ first and then column LGSEQ both green arrows.

Below is what I would like the new database to look like. One single record for unique value in LGLOGO but with the data laid out across the row for each step in the sequence. Any help with a code or how to build the Macro or Query would be great as I do not know how or where to start. Thanks!

 

[OasisUnknown]

Hey Cmac, I hate to say it but your images did not come across so unfortunately I cant see what you were talking about to make an educated guess on how to accomplish your task.

 

[Cmac941]

Sorry, here is the rough data without the arrows...

LGVEND	LGLOGO	LGSEQ	LGPCOD	LGCSEQ	LGCCOD
58890	H044MOM	1	ST	1	2
58890	H044MOM	1	ST	2	40
58890	H045	1	ST	1	1
58890	H045	1	ST	2	28
58890	H047	1	ST	1	2
58890	H052	1	FC	2	1
58890	H052	1	FC	1	2
58890	H052	1	FC	3	10
58890	H056	1	ST	1	2
58890	H056	1	ST	2	31
58890	H058	1	ST	1	1
58890	H058	1	ST	2	6
17367	FE77	4	BA	3	1
17367	FE77	2	LS	3	1
17367	FE77	1	LC	1	4
17367	FE77	2	LS	1	4
17367	FE77	4	BA	2	4
17367	FE77	2	LS	2	6
17367	FE77	4	BA	5	6
17367	FE77	4	BA	1	10
17367	FE77	1	LC	2	20
17367	FE77	4	BA	4	20
17367	FE77	3	RS	1	99

<tbody>
</tbody>

Desired results

LGLOGO	LGSEQ	LGPCOD	LGCSEQ	LGCCOD	LGSEQ	LGPCOD	LGCSEQ	LGCCOD	LGSEQ	LGPCOD	LGCSEQ	LGCCOD	LGSEQ	LGPCOD	LGCSEQ	LGCCOD	LGSEQ	LGPCOD	LGCSEQ	LGCCOD
H044MOM	1	ST	1	2	1	ST	2	40
H045	1	ST	1	1	1	ST	2	28
H052	1	FC	1	2	1	FC	2	1	1	FC	3	10
H056	1	ST	1	2	1	ST	2	31
H058	1	ST	1	1	1	ST	2	6
FE77	1	LC	1	4	1	LC	2	20
FE77	2	LS	1	4	2	LS	2	6
FE77	3	RS	1	99
FE77	4	BA	1	10	4	BA	2	4	4	BA	3	1	4	BA	4	20	4	BA	5	6

<tbody>
</tbody>