| 11-04-2018 | Packing Materials GST12 | GST Purchase1819 | 38326.00 | |
| New Ref | GST/647 / 060418 | 60 Days | Cr |
This one of the tally data exported to excel now i want re arrange the yellow color data in single row if any one please help to to do this in excel because its a big data manual it is not possible to do for reconcile purpose its required please help me to do this
Can you post the excel data file, if there isn't anything sensitive...
Dear sir,
Please find the attached Excel file.
Sir,
column B Purchase Ledger and Column C is invoice reference number invoice reference sitting in row number 4 if i filter column B inv reference not coming for me Date, Purchase Ledger, Inv Reference, and Inv value should come in row number 3 or row number 4.
Sorry... overlooked the voucher number column earlier... kindly see the revised file attached...
Following has been done...
Cut entire voucher number column by clicking on top of the row... paste it in another sheet... remove the topmost blank cell... again cut from there and paste back in the table after clicking on top of the table... that one space issue in every alternate cell will be resolved for filtration... Now you will get the result by filtering the data...
There can be other ways too to resolve this issue... but at present, i could do this way only...
CAclubindia
