Rows of grouped data into one Row

[Masond3]

Hi All, 

I am having abit of a mare and struggling to think of how to solve this use case. 

I have the following excel and the data structure is as follows, ( every 2 rows are a group) 

Source	Identifier	Name	Address
UNKNOWN	xxxxxxxx	Mason LTD	123 High Street
DB	111111111	Mason LTD	1234 High Street

My steps so far is as follows ;

• Add a "Record ID" Create a new column called RecordID
• Add a formula with the following  CEIL([RecordID]/2)

This gives me the following 

Record	Source	Identifier	Name	Address	Group
1	UNKNOWN	xxxxxxxx	Mason LTD	123 High Street	1
2	DB	111111111	Mason LTD	1234 High Street	1

From here what i would like to do is get to this outcome 

Group	Identifier	Identifier	Name	Name	Address	Address
1	xxxxxxxx	111111111	Mason LTD	Mason LTD	123 High Street	1234 High Street

Really appreciate any assistance 

Kind Regards

Masond3

[Luke_C · Accepted solution]

Hi @Masond3 

Here's an example of an approach you can take. Note, you can't have multiple fields with the same name.