Any excel wiz here? Urgent

[Anudawan]

Sorry posting for traffic.

ive got a huge task of moving over 2000 inputs from one file to another, they have variable in puts, and the two file table designs do not match one another.

tell me there is another way than having to literally type out over 2000 lines of data?

Not at all, power queries are the most complex thing you can really do on Excel. Hardly anyone who uses Excel can use them, which is why it was a bit of a silly suggestion. If you were at that level, you would not have needed to ask for help, you’d be the person everyone came to for help with their Excel issues.

Use power query from within excel
ask chatgpt for details of what to do

AI is your friend!
Use Chatgpt, or Copilot if you have access to it. If you've not used it before, you literally just type in what you want to do and it will give you a solution.
If the solution isn't quite what you need, keep adding more specific detail until it's drilled down to exactly what you want.

Will likely be faster, and more accurate, than waiting for MN responses 😉

ok so dealing with number of fish. You need to split the column where the hyphen is. If you can't split the column using the split column tool, then do something like this:

If you want to grab the first number, you could use something like:

=left(2, <number of fish cell>)

Then that would cover numbers 1 through 10 for fish. you'd pick up the hyphen for numbers of fish <10. Simply do a find and replace on that column to remove the hyphens.

Same for the upper limit. Use something like =right(2, <number of fish cell>).

Oh and with my cybersecurity hat on, DO NOT UPLOAD COMPANY DATA TO CHATGPT!!

I wanted to throw my phone at the wall after chat gpt I kept getting formula errors lol

Oh absolutely - I meant ask chatgpt how to do what you want to do

To revive this thread slightly. Can anyone recommend any free/ low cost excel courses I could go on?

I have no idea how good it would be, but I've googled and seen this Udemy Course is £14.99 https://www.udemy.com/share/101Wde/