• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Formatting

M

Manuel998

Member
Hi,

I have some data and it is received in the following format:

upload_2017-4-5_16-25-12.png


And i need to bring it into this format:

RESUNRES
SCOA
SOFA
SUBSOFA
VAT_TREATN
FIXDASSTS

the first two colums will have a unique code and the next two will have another my question is how i can have a formula or set up the spreasheet so the when the code changes it picks up the details in the next sequence
 

Attachments

  • Copy of Acc code set up BXHX994BXHX996BXHX997.xlsx
    9.7 KB · Views: 3
You must log in or register to reply here.
Back
Top