I have a worksheet with a column A where numerical and text are mixed, the numbers represents tax rate .
the worksheet has been condensed for ease of understanding as it represents data of 12000 rows .
formula to split numerical data only to their respective tax column headers COLUMN B, C and D
Bookmarks