ExcelBanter - adding to lines

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - adding to lines (https://www.excelbanter.com/excel-discussion-misc-queries/263502-adding-lines.html)

balurrpr

adding to lines

Hi,

i am getting an output with two rows like -

Item Description Category
2300798-2 1.5T HEAD/BODY

Receipt Receipt
Date Number
28-Apr-10 21641

how can i add above two lines in one row means after CATEGORY i need RECEIPT
DATE & NUMBER

All times are GMT +1. The time now is 10:08 PM.