Help required in Converting Multiple Rows to Columns and add Column Headers

[Swaroopa]

I'm currently faced with a spreadsheet that has data formatted like this:

[MEMBER]
userid=ABC
last_name=DEF
first_name=ABD
[email protected]
telephone=xxxxxxxx
fax=8888888
title=Engineer
department=abcd
group=admin
[MEMBER]
userid=XYZ
last_name=IJK
access=0
role= MMM
group=consultant
[MEMBER]
userid=SSUSER
access=1
role=MMD
group=ADS

Every [MEMBER] is a new set of data that repeats itself. But might not have all the entries compared to other set.

I need to figure out a way to get the data in below mentioned format.


userid last_name first_name email_address telephone fax title department role group access
ABC DEF ABD [email protected] xxxxxxxx 8888888 Engineer abcd admin
XYZ IJK MMM consultant 0
SSUSER MMD ADS 1

Any help is greatly appreciated.

Regards,
Swaroopa

[xlbiznes]

Hi,

Attached is my solution. Hope this helps.

[Swaroopa]

Thanks Xlbiznes.. It worked perfectly.

Regards,
Swaroopa.

[Swaroopa]

I have another requirement where the initial data is in the below format.
dia 1.JPG

Where as I want the data in below mentioned format.

dia 2.JPG

Regards,
Swaroopa

[xlbiznes]

Hi,

Attached is your solution to extract data in the new format. You need to change the values in the array (col_headers) to suit your requirement.