| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Fill-in empty cells from SAP report
When extracted to Excel, many reports from SAP do not come in a clean table
format but they appear with blank cells. For example: Column A Column B Column C Column D 2200352479 UB Plant 1311 Item1 75,00 EA Item2 10,75 EA 2500045255 VB Plant 1511 Item1 25,00 EA Item2 15,75 EA Item3 10,50 EA Is there a way to fill-in the blank cells below the numbers in Column A so afterward I can make a pivot table? This is the desired result: 2200352479 UB Plant 1311 2200352479 Item1 75,00 EA 2200352479 Item2 10,75 EA 2500045255 VB Plant 1511 2500045255 Item1 25,00 EA 2500045255 Item2 15,75 EA 2500045255 Item3 10,50 EA Many thanks in advance. --------- Ilieski |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display empty cells | Excel Discussion (Misc queries) | |||
| How can I convert empty strings to empty cells? | Excel Discussion (Misc queries) | |||
| fill red cells included in formula - ajit | Excel Discussion (Misc queries) | |||
| HOW TO FORMATE CELLS TO COUNT CELLS WITH A FILL COLOR? | New Users to Excel | |||
| Trendlines to ignore empty cells | Charts and Charting in Excel | |||
Threaded Mode
