Excel data

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  

Replies (5)

Can you post the excel data file, if there isn't anything sensitive...

Dear sir,

 

 Please find the attached Excel file.

  • Select the table
  • Data -> Filter
  • Column B drop down icon
  • Uncheck ‘Select All’
  • Select only ‘Packing Materials’
  • Ok

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...

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
26 September 2026
Chartered Accountant

pushpganga ventures

Pune

CA

View Details
Company
30 September 2026
Senior Accounts Executive

Codeboard Technology

Chennai

MBA

View Details
Company
ARTICLESHIP 28 September 2026
Junior Accountant

J S P M & Associates LLP

Pune

B.Com

View Details
Company
ARTICLESHIP 07 October 2026
Article Trainee/ CMA Trainee

RMA And Associates LLP

New Delhi

CA Inter

View Details
Company
14 October 2026
Accountant

Rize.farm

Bengaluru

B.Com

View Details
Company
12 October 2026
Finance

I-Genext Consulting Private Limited

New Delhi

CA

View Details
Company
08 October 2026
Accounts and Tax Associate

POOJA R TELI & CO

Pune

CA Inter

View Details
Company
Featured 03 October 2026
Accountant

A P Lodha and Associates

Jalna

B.Com

View Details