| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Transpose Column to Rows
I have around 1600 Name along with company
name,Address1,Address2,City,State,Pincode For Ex: Mr.hardeep Kanwar Bi/200 Yamuna Vihar Dehi 110053 Some times it has 5data as mentioned in the Example, Sometime4 and sometimes 6 And in the end of every data there is a Blank Row Like This Mr.hardeep Kanwar Bi/200 Yamuna Vihar Dehi 110053 Blank Ms. Danielle Fran American Cancer Society 1555 Abbey Road East Lansing, MI 48823 Blank Now i want to Convert like this Mr.hardeep Kanwar Bi/200 Yamuna Vihar Dehi 110053 Ms. Danielle Fran American Cancer Society 1555 Abbey Road East Lansing, MI 48823 But Without using Marco. Any Help will be Highly Appreciate Hardeep Kanwar |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Transpose column into rows for use as mailmerge data | Excel Discussion (Misc queries) | |||
| Transpose data from many horizontal rows into a single column | Excel Discussion (Misc queries) | |||
| Can you transpose 1 column into multiple rows creating a table | Excel Discussion (Misc queries) | |||
| Transpose Data from a column to several rows | Excel Worksheet Functions | |||
| transpose a column into many rows | Excel Discussion (Misc queries) | |||
Threaded Mode
