i have sheet including a start date & sf id and I need to combine them in one column as a reference but when I try to do this I found an error as shown in the P.S, So can I solve this error

I have several spreadsheets I would like to combine into one and have each sheet on a separate tab. Is there a solution in Excel that can be used?

I don't know if the correct thing is to combine the columns but I have the following problem that I would like to solve with you and you can give me a better orientation and it is the following: I hav...

I know, this is something that should be done at the level of the data model as a star Schema but in this specific case it is not possible. I have 1 dimensional table and 4 transactional tables. All o...