How to combine date and time columns into one column in Google sheets?

In Google sheets, you need to combine the date column and time column into one column as following screenshot shown, how could you deal with it in Google sheets?

Combine the data in two (or more) different columns in Google Sheets together. Each row's cells can be merged and the output is combined with optional extra. Your admin colleagues have fallen into the common trap of confusing the collection of data with the reporting and viewing of data. In general, you collect data in a single table, with each row containing all the info for that entry. Typically, date, name, and other info all exist on each row in the table.

Combine date and time columns into one column with formula

To combine the date and time columns into one column, the following formula can help you:

1. Enter this formula: =concatenate(text(A2,'mm/dd/yyyy')&' '&text(B2,'hh:mm:ss'))into a blank cell where you want to put the combined result, then press Enter key to get the first combined cell.

2. And then select the formula cell and drag the fill handle down to the cells you want to combine, and the date and time columns have been combined into one column, see screenshot:

The Best Office Productivity Tools

Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%

  • Reuse: Quickly insert complex formulas, charts and anything that you have used before; Encrypt Cells with password; Create Mailing List and send emails..
  • Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range..
  • Merge Cells/Rows/Columns without losing Data; Split Cells Content; Combine Duplicate Rows/Columns.. Prevent Duplicate Cells; Compare Ranges..
  • Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select..
  • Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more..
  • Extract Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments..
  • Super Filter (save and apply filter schemes to other sheets); Advanced Sort by month/week/day, frequency and more; Special Filter by bold, italic..
  • Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF..
  • More than 300 powerful features. Supports Office/Excel 2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features 30-day free trial. 60-day money back guarantee.

Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier

  • Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
  • Open and create multiple documents in new tabs of the same window, rather than in new windows.
  • Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
or post as a guest, but your post won't be published automatically.
Loading comment.. The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    It doesn't work. I do not understand the message below.
    I don't need it explained to me. I just need a formula that works please.
    Thank you.
    'There's a problem with this formula.
    Not trying to type a formula?
    When the first character is an equal(=) or minus (-) sign, Excel thinks it's a formula.
    you type: =1=1, cell shows : 2
    To get around this, type an apostrphe (') firts:
    you type: '=1=1, cell shows: =1+1'
    I have replaced the rows and cells numbers and letters and have done it several times.
  • To post as a guest, your comment is unpublished.
    Apologies, I want to withdraw my previous comment. (I copied and pasted the formula, and I now realise that I can change the format.)
  • To post as a guest, your comment is unpublished.
    This does not work with Australian date formats. 12/10/2020 (27 Nov) when combined with the time will show 10/12/2020 (10 Dec).
  • To post as a guest, your comment is unpublished.
    Hello! I want to pull the column data into a cell (not row) separated by comma. And column contains all dates. Please provide the solution

How to combine multiple columns into one single column in Google sheet?

Google Sheets Merge Columns

Do you have any good methods to combine multiple columns data into a single column without copying and pasting one by one in Google sheet? May be this article can help you to finish this job quickly and easily.

Combine multiple columns into a single column in Google sheet

In Google sheet, you can apply an easy formula to solve this task, please do as this:

Google sheets combine two cells

1. Enter this formula: =FILTER({A2:A7;B2:B8;C2:C8}, LEN({A2:A7;B2:B8;C2:C8})) into a blank cell where you want to output the result, see screenshot:

Note: In above formula, A2:A7, B2:B8, C2:C8 is the column's data that you want to combine, you can change them to your need.

2. And then press Enter key, the specific column's data have been combined into one single column, see screenshot:

Combine multiple columns into a single column in Microsoft Excel

If you need to combine multiple columns into a single column in Microsoft Excel worksheet, I will introduce you a handy tool-Kutools for Excel, with its Transform Range feature, you can quickly combine multiple columns into one single column or single row.

Kutools for Excel: with more than 300 handy Excel add-ins, free to try with no limitation in 30 days.

After installing Kutools for Excel, please do as this:

1. Select the columns that you want to combine, and then click Kutools > Range > Transform Range, see screenshot:

2. In the Transform Range dialog box, select Range to single column option in the Transform type section, see screenshot:

3. Then click Ok button, and in the popped out dialog box, select a cell where you want to output the result, see screenshot: Free fire pdf free download.

4. And then click OK, the selected columns have been combined into one single column, see screenshot´╝Ü

The Best Office Productivity Tools

Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%

Combine Data Columns In Google Sheets Excel

  • Reuse: Quickly insert complex formulas, charts and anything that you have used before; Encrypt Cells with password; Create Mailing List and send emails..
  • Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range..
  • Merge Cells/Rows/Columns without losing Data; Split Cells Content; Combine Duplicate Rows/Columns.. Prevent Duplicate Cells; Compare Ranges..
  • Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select..
  • Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more..
  • Extract Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments..
  • Super Filter (save and apply filter schemes to other sheets); Advanced Sort by month/week/day, frequency and more; Special Filter by bold, italic..
  • Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF..
  • More than 300 powerful features. Supports Office/Excel 2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features 30-day free trial. 60-day money back guarantee.

Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier

  • Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
  • Open and create multiple documents in new tabs of the same window, rather than in new windows.
  • Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
or post as a guest, but your post won't be published automatically.
Combine Data Columns In Google Sheets

How To Combine Two Columns In Google Sheets

Loading comment.. The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    Great one, but If you need to combine many columns into one that will be a painful operation.
    You can use the STACKARRAY function: https://chrome.google.com/webstore/detail/stackarray-stack-all-colu/djkbffiggnmhgchmlejbfmghlidkajof
    just write =STACKARRAY(the_array_to_combine) and that will just stack the columns
  • To post as a guest, your comment is unpublished.
    FILTER range must be a single row or a single column.
  • To post as a guest, your comment is unpublished.
    I would like to get the merged column on a new sheet. How do I modify this formula so that it references the columns on another sheet.
    Thanks!
    • To post as a guest, your comment is unpublished.
      Hello, NYeducator,
      To combine multiple columns data into one list in a new sheet, you just need to the following formula: (Note: Sheet3 is the sheet name that contains the columns data that you want to merge)
      =FILTER({Sheet3!A2:A7;Sheet3!B2:B8;Sheet3!C2:C8}, LEN({Sheet3!A2:A7;Sheet3!B2:B8;Sheet3!C2:C8}))
      Apply the above formula in a new sheet.
      Please try it, hope it can help you!
  • To post as a guest, your comment is unpublished.
    Unfortunately this does not work in Google Sheets as it will place the data in one column beneath each other.
  • To post as a guest, your comment is unpublished.
    Thank You!
    PS: modified to account for any future inputs in Columns A and/or B..
    =FILTER({A2:A;B2:B}, LEN({A2:A;B2:B}))
    Thanks again