| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
From Column to Row without blank cells
I have 3 columns of data 1st being names then date and time and finally event
scores, I want to move the names colunm to rows but only taking one instance, then leave the date and time in column format. Now I need to fill each row with the score relivent without having a blank cell. I have tried using IF statments but after the first cell has been used it moves over 1 cell and down 1 cell to put the next event score. Please can you help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I can't autofill cells in a column if blank cells in between | Excel Worksheet Functions | |||
| Deleting blank cells in a column | Excel Programming | |||
| removing blank cells from a column | Excel Discussion (Misc queries) | |||
| HELP: Last row of the column containing blank cells between non-blank cells | Excel Worksheet Functions | |||
| Skipping blank cells in a column... | Excel Programming | |||
Threaded Mode
