Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: How to pick up data from multiple columns ?
Hi,
I have the following table at my worksheet: Each row contains only a text or a number. A B C D 1 Hp Hp <- only one entry per row 2 Qt Qt 3 Kx Kx 4 Qt Qt 5 Hp Hp 6 Kx Kx 2500 May I know what formula to input at cell D1 and copy down to pick up the data from each cell in column A to C as illustrated ? Thanks Low -- A36B58K641 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: How to pick up data from multiple columns ?
Put this in D1:
=A1 & B1 & C1 and copy down as required. Hope this helps. Pete On Aug 5, 2:33*pm, Mr. Low wrote: Hi, I have the following table at my worksheet: Each row contains only a text or a number. * * * * * *A * * * * B * * * * C * * * * D 1 * * * * Hp * * * * * * * * * * * * * * Hp <- only one entry per row 2 * * * * * * * * * * * * * * *Qt * * * *Qt 3 * * * * * * * * * Kx * * * * * * * * * Kx 4 * * * * * * * * * * * * * * *Qt * * * *Qt 5 * * * * Hp * * * * * * * * * * * * * * Hp 6 * * * * * * * * * Kx * * * * * * * * * Kx 2500 May I know what formula to input at cell D1 and copy down to pick up the data from each cell in column A to C as illustrated ? Thanks Low -- A36B58K641 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel 2002 question for pick from list with autocomplete function | Excel Worksheet Functions | |||
Excel 2002 : How to extract data from columns ? | Excel Discussion (Misc queries) | |||
adding up columns in excel 2002 | Excel Worksheet Functions | |||
Excel 2002 : Formula to pick up codes | Excel Discussion (Misc queries) | |||
Finding common data in multiple columns and rows in Excel | Excel Worksheet Functions |