Home |
Search |
Today's Posts |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
moving data to one row
Try this
Sub allonerow() mc = "a" For i = Cells(Rows.Count, mc).End(xlUp).row To 1 Step -2 Cells(i - 1, mc) = Cells(i - 1, mc) & " " & Cells(i, mc) Rows(i).Delete Next i End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "stacie" wrote in message ... I have pasted data into an excel spreadsheet, but the data is on two different lines ex: A6530 COMPRESSION STOCKING BK18-30 A9900 2 PAIR $ 45.46 L3908 WHO, WRIST EXTENSION A9900 1 EACH $ 11.81 I need all of the data on one line like this: A6530 COMPRESSION STOCKING BK18-30 A9900 2 PAIR $ 45.46 L3908 WHO, WRIST EXTENSION A9900 1 EACH $ 11.81 Is there a way to do this in excel? -- stacie |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving a line chart data point revises data table value in Excel ' | Charts and Charting in Excel | |||
moving data to non autofarmatted book changes data- Why? | Excel Discussion (Misc queries) | |||
moving data | Excel Discussion (Misc queries) | |||
Moving data | Excel Worksheet Functions | |||
moving data in excel without deleting existing data | Excel Discussion (Misc queries) |