Excel data

Others 258 views 5 replies
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...


CCI Pro

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
Featured 19 March 2026
Article Assistant

Gupta Sachdeva & Co. Chartered Accountants

New Delhi

CA Final

View Details
Company
Featured 13 April 2026
GST CONSULTANCY

Abhishek G Agrawal & Co.

Korba

CA Final

View Details
Company
Featured 14 April 2026
GST CONSULTANT

Abhishek G Agrawal & Co.

Korba

CA Final

View Details
Company
Featured 28 March 2026
CA Final

Ashok Amol & Associates

New Delhi

CA Final

View Details
Company
Featured 14 March 2026
Associate CA

N N V Satish&co

Hyderabad

CA

View Details
Company
Featured 12 March 2026
Customer Relationship Executive

TAXLET

Calicut

B.Com

View Details
Company
Featured 14 March 2026
Article Trainee

N N V Satish&co

Hyderabad

CA Inter

View Details
Company
Featured 28 March 2026
Accountant

Ashok Amol & Associates

New Delhi

B.Com

View Details