Merge data

Hi all

I am struggling with merging and would like to know if someone can help me please.

I have attached a sample spreadsheet.

as set out in the spreadsheet highlighted in green I would like to do the following

Cell A2 data needs to be brought over with a fomular into Cell C15 maintaining the subject in C15 as set out in sample L15
the same with

A2 into Cell C15
B2 into Cell C11
C2 Into Cell C12
D2 Into Cell B14
E2 Into Cell C13
F2 Into Cell C16

As in the sample sheet I have to manually copy the information into the column as indicated in the sheet under sample highlighted in yellow and red name sample.

Please assist me with a formula in cells C11,C12, ,C13 and C15 , C16 and B14 to bring information in row 2 into the above column without removing the information in these cell.


Your help will be gladly appreciated.

Regar

Hi John.

Thank you very much for the formula.

I am struggling with A2 into Cell C15

as it brings up this error Support Dated : :# 45756.5455324074

as A2 is a date range.

is there any formula for the date range one.

Will appreciated your feedback thanks in advance.

Hi Pepe.

Thank you very much, highly appreciated it

Just a last one is there a way besides merge. I would like all information In cell F2 to be slip into 2 or more cell example below
Let me know if there is a formula.


Thanks in advance

Body
Checked backup jobs for the week Cell 1
- all completed successfully. Cell 2

Hi Pepe Le Mokko

My humble apologies for not including the sample sheet in the thread.

I am attaching.

Look at the highlighted cell G2 as all the content is in the sheet and needs to be split as per cell C15 till C21.

Please advise if there is a way to have this done.

as i need to copy the cell to a notepad manually, and then I need to split it in the notepad and then copy it over into Excel in order to create the invoice.

Your Feedback would be appreciated.

The splitting can be done on a number of characters
as the line item only allows a certain number of characters
only 54 characters are allowed in the line
and as you can see as per the same sheet i have send it is more than that and the client would not be able to see the entire breakdown

we are currently using Microsoft 365 Apps for Enterprise.