Arranging vertical data to a horizontal table

Question

Hello Gurus,

I have a requirement of arranging data in the vertical multi row data to a simple horizontal table. Any advice on how to achieve this is greatly appreciated.

FirstName   LastName   Ph.num1234567890  zip code   CityPhoenixSpouse FirstName CountryUSSpouse LastName Address

to

FirstNameLastNamePh.numzip codeCityCountryAddressSpouse FirstNameSpouse LastName  1234567890 PhoenixUS

FinnCharlton · Accepted Answer

Hi @sharavanarcot ,

Here is one way to do this:

ShankerV · Accepted Answer

Hi @sharavanarcot

One way of doing this.