How to concatenate (Combine) multiple columns into one field in MS Excel

 In MS Excel, We have multiple columns data where we want to combine all these columns data to a single column.

There is a two way  to do that .

Example-1:

Create a new column and give and concat all the data 

Use the CONCATENATE function in that new column. 

=CONCATENATE(A2,B2,C2).

Example-2

=concatenate A1&B1&C1 and press Enter

if you want add some special character between the columns data such as (space,comma,dash, etc ), You can use the below formula .

=CONCATENATE(A1&" ," &B1&", " & C1&","&D1&"," &E1&"," &F1&","&G1)

My LibreNMS suddenly Stopped Pooling the Devices .

 There is some bug in libre NMS i found that suddenly my pooling has been stopped without any reason. SO to re run it i just rerun my daily.sh and validated the php to rerun it .

[root@localhost ~]# su - librenms
[librenms@localhost ~]$ ./validate.php
===========================================
Component | Version
--------- | -------
LibreNMS  | 24.8.0-72-g7d450345d (2024-09-15T05:43:11+05:30)
DB Schema | 2024_08_27_182000_ports_statistics_table_rev_length (299)
PHP       | 8.1.21
Python    | 3.6.8
Database  | MariaDB 10.3.28-MariaDB
RRDTool   | 1.7.0
SNMP      | 5.8
===========================================
[OK]    Composer Version: 2.7.9
[OK]    Dependencies up-to-date.
[OK]    Database connection successful
[OK]    Database connection successful
[OK]    Database Schema is current
[OK]    SQL Server meets minimum requirements
[OK]    lower_case_table_names is enabled
[OK]    MySQL engine is optimal
[OK]    Database and column collations are correct
[OK]    Database schema correct
[OK]    MySQL and PHP time match
[OK]    Active pollers found
[OK]    Dispatcher Service not detected
[OK]    Locks are functional
[OK]    Python poller wrapper is polling
[OK]    Redis is unavailable
[OK]    rrd_dir is writable
[OK]    rrdtool version ok
[WARN]  Your install is over 24 hours out of date, last update: Sun, 15 Sep 2024 00:13:11 +0000
        [FIX]:
        Make sure your daily.sh cron is running and run ./daily.sh by hand to see if there are any errors.

[librenms@localhost ~]$ 
[librenms@localhost /]$ su root
Password:
[root@localhost /]# cd opt/librenms/
[root@localhost librenms]# sudo ./daily.sh
Re-running /opt/librenms/daily.sh as librenms user
Updating to latest codebase                        OK
Updating Composer packages                         OK
Updated from 7d450345d to 7034fd7a4                OK
Updating SQL-Schema                                OK
Updating submodules                                OK
Cleaning up DB                                     OK
Fetching notifications                             OK
Caching PeeringDB data                             OK
[root@localhost librenms]#