Transforming Columns into Rows

Question

Currently, all the information is in Row 1. Cell A1 has a Name. Cell B1 has an Address. Cell C1has a City. Cell D1 has a Name. Cell E1 has an Address. Cell F1 has a City. This 3 cell sequence repeats many times in Row 1.

I would like all the Names be in Column A. All the Addresses be in Column B. All the Cities in Column C. The end result would have information presented as follows:

Name Address City

A1 B1 C1

D1 E1 F1

G1 H1 I1

Etc

Etc

How can I accomplish this?

Thank you

Answer 1

Re: Convert data now in one row

Please see my response to an almost identical question in this forum... https://answers.microsoft.com/en-us/msoffice/forum/all/excel/fb248a24-c14f-48a9-9389-84bd6a3a94be?messageId=5ff41eb6-d71a-412c-b7d7-8e559c84d80f

It is titled "Excel" from July 17, 2022 by Tyty92

'---

Nothing Left to Lose

https://1drv.ms/u/s!Au8Lyt79SOuhZw2MCH7_7MuLj04?e=sAwbHU

(free excel programs)

Answer 2

Hi. Thank you for your question and reaching out. My name is John and I’d be more than happy to help you with your query.

Assuming that you have a worksheet with information in sections that you want to turn to rework it in columns, utilize the Translate highlight. With it, you can rapidly change information from segments to columns, or the other way around. For more information, please see https://support.microsoft.com/en-us/office/3419f2e3-beab-4318-aae5-d0f862209744

Best regards, John

Answer 3

This is difficult for me to follow. Could you please explain it in a more simple, step by step manner.

Thank you

Answer 4

try this ...

create temp table aa as select (rowid-1) /3 rows,(case 'c'||((rowid-1) % 3) when 'c0' then 'Name' when 'c1' then 'Addess' else 'City' end) cols,* from TransformingColumnsintoRows; select * from aa limit 9; cli_create_two_dim_no_order~aa~cols~content; select * from aa_two_dim;